﻿using System;using ERP_RORZE_SYSTEM;
using System.Collections.Generic;
using System.Linq;
using System.Text;
using System.Threading.Tasks;

namespace ERP_RORZE_DLL.Product.Base
{
    public class clsConstantsSP
    {
        #region QMaterial
        public class ClsQMaterialSP
        {
                public const string RecordNo = "@RecordNo";
                public const string QuotationID = "@QuotationID";
                public const string MPartNo = "@MPartNo";
                public const string MaterialID = "@MaterialID";
                public const string MaterialType = "@MaterialType";
                public const string MaterialPrice = "@MaterialPrice";
                public const string Shape = "@Shape";
                public const string Thickness = "@Thickness";
                public const string Length = "@Length";
                public const string Width = "@Width";
                public const string Price = "@Price";
                public const string Note = "@Note";
        }
        #endregion

        #region Qmachine
        public class ClsQmachineSP
        {
                public const string RecordNo = "@RecordNo";
                public const string InputDate = "@InputDate";
                public const string QuotationID = "@QuotationID";
                public const string StaffID = "@StaffID";
                public const string MPartNo = "@MPartNo";
                public const string MachineID = "@MachineID";
                public const string OptionID = "@OptionID";
                public const string ProTime = "@ProTime";
                public const string ClampTime = "@ClampTime";
                public const string Note = "@Note";
        }
        #endregion
            #region AnodQtyChange
            public class ClsAnodQtyChangeSP
            {
                    public const string ID = "@ID";
                    public const string Date = "@Date";
                    public const string StaffID = "@StaffID";
                    public const string Mono = "@Mono";
                    public const string OKtoNGQty = "@OKtoNGQty";
                    public const string NGtoOKQty = "@NGtoOKQty";
                    public const string note = "@note";
                    public const string finished = "@finished";
                
            }
            #endregion

            #region BusOder
            public class ClsBusOderSP
            {
                    public const string BOderNo = "@BOderNo";
                    public const string date = "@date";
                    public const string planNo = "@planNo";
                    public const string PartID = "@PartID";
                    public const string Qty = "@Qty";
                    public const string Dealine = "@Deadline";
                    public const string RawQty = "@RawQty";
                    public const string HelisertQty = "@HelisertQty";
                    public const string BlastQty = "@BlastQty";
                    public const string MONo = "@MONo";
                    public const string MOQty = "@MOQty";
                    public const string Started = "@Started";
                    public const string Finished = "@Finished";
                    public const string FinishDate = "@FinishDate";
                    public const string Change = "@Change";
                    public const string ChangeDate = "@ChangeDate";
                    public const string Imported = "@Imported";
                    public const string ImportFrom = "@ImportFrom";
                    public const string Note = "@Note";
                
            }
            #endregion
            #region Material
            public class ClsDBMaterial
            {
                    public const string MaterialID = "@MaterialID";
                    public const string Density = "@Density";
                    public const string UnitPrice = "@UnitPrice";
                    public const string Type = "@Type";
                
            }
            #endregion
            #region MonthlyLaborCharge
            public class ClsMonthlyLaborChargeSP
            {
                    public const string LRecordNo = "@RecordNo";
                    public const string LMonthYear = "@MonthYear";
                    public const string LMonth = "@Month";
                    public const string LYear = "@Year";
                    public const string LabCharge = "@LabCharge";
            }
            #endregion

            #region Quotation
            public class ClsQuotationSP
            {
                    public const string QuotationID = "@QuotationID";
                    public const string Date = "@Date";
                    public const string CustomerID = "@CustomerID";
            }
            #endregion

            #region MonthlyMachineCharge
            public class ClsMonthlyMachineChargeSP
            {
                    public const string MRecordNo = "@RecordNo";
                    public const string MMonthYear = "@MonthYear";
                    public const string MMonth = "@Month";
                    public const string MYear = "@Year";
                    public const string MachineID = "@MachineID";
                    public const string MacCharge = "@MacCharge";
            }
            #endregion

            #region Part
            public class ClsPastSP
            {
                public const string PartID = "@PartNo";
                public const string PartName = "@PartName";
                public const string CustomerID = "@CustomerID";
                public const string SupplierID = "@SupplierID";
                public const string UpQty = "@UpQty";
                
            }
            #endregion

            #region CapCalculation
            public class ClsCapCalculationSP
            {
                    public const string ID = "@ID";
                    public const string DeadLine = "@DeadLine";
                    public const string CustomerID = "@CustomerID";
                    public const string MachineID = "@MachineID";
                    public const string Time = "@Time";
                
            }
            #endregion

            #region Configure
            public class ClsConfigureSP
            {
                    public const string ConfigureID = "@ConfigureID";
                    public const string ConfigureName = "@ConfigureName";
                
            }
            #endregion

            #region DailyMachineTime
            public class ClsDailyMachineTimeSP
            {
                    public const string ID = "@ID";
                    public const string date = "@date";
                    public const string Shift = "@Shift";
                    public const string MachineID = "@MachineID";
                    public const string WorkID = "@WorkID";
                    public const string Time = "@Time";
                
            }
            #endregion

            #region DAnodInsp
            public class ClsDAnodInspSP
            {
               
                    public const string ID = "@ID";
                    public const string date = "@date";
                    public const string MONo = "@MONo";
                    public const string StaffID = "@StaffID";
                    public const string AOKQTY = "@AOKQTY";
                    public const string ANGQTY = "@ANGQTY";
                    public const string Note = "@Note";
                    public const string Finished = "@Finished";
                
            }
            #endregion

            #region DataSheet
            public class ClsDataSheetSP
            {
                
                    public const string ID = "@ID";
                    public const string PageNo = "@PageNo";
                    public const string date = "@date";
                    public const string code = "@code";
                    public const string StaffRegister = "@StaffRegister";
                    public const string Form = "@Form";
                    public const string Thickness = "@Thickness";
                    public const string Loaivl = "@Loaivl";
                    public const string KTP = "@KTP";
                    public const string Length = "@Length";
                    public const string Width = "@Width";
                    public const string number = "@number";
                    public const string ConfigureName = "@ConfigureName";
                    public const string KDID = "@KDID";
                    public const string RessionID = "@RessionID";
                    public const string cut = "@cut";
                    public const string Handl = "@Handl";
                    public const string MaTrang = "@MaTrang";
                    public const string MaDen = "@MaDen";
                    public const string HairLine = "@HairLine";
                    public const string Seal = "@Seal";
                    public const string Bafu = "@Bafu";
                    public const string Migaky = "@Migaky";
                    public const string Blast30 = "@Blast30";
                    public const string Blast60 = "@Blast60";
                    public const string WashSA = "@WashSA";
                    public const string Helisert = "@Helisert";
                    public const string SerialClose = "@SerialClose";
                    public const string VacuumPacked = "@VacuumPacked";
                    public const string PalCoat = "@PalCoat";
                    public const string Drawn = "@Drawn";
                    public const string MaBong = "@MaBong";
                    public const string Casiras = "@Casiras";
                    public const string InLuoi = "@InLuoi";
                
            }
            #endregion

            #region DBusInsp
            public class ClsDBusInspSP
            {
                    public const string ID = "@ID";
                    public const string Date = "@Date";
                    public const string MONo = "@MONo";
                    public const string StaffID = "@StaffID";
                    public const string BusQty = "@BusQty";
                    public const string Note = "@Note";
                    public const string Finished = "@Finished";
                
            }
            #endregion

            #region DF3Store
            public class ClsDF3StoreSP
            {
                    public const string ID = "@ID";
                    public const string date = "@date";
                    public const string MONo = "@MONo";
                    public const string StaffID = "@StaffID";
                    public const string STOKQTY = "@STOKQTY";
                    public const string STSPQty = "@STSPQty";
                    public const string STNGQty = "@STNGQty";
                    public const string Note = "@Note";
                    public const string Finished = "@Finished";
                
            }
            #endregion

            #region DHandInsp
            public class ClsDHandInspSP
            {
                    public const string ID = "@ID";
                    public const string date = "@date";
                    public const string MONo = "@MONo";
                    public const string StaffID = "@StaffID";
                    public const string OKQty = "@OKQty";
                    public const string NGQty = "@NGQty";
                    public const string Note = "@Note";
                    public const string Finished = "@Finished";
                
            }
            #endregion

            #region DInspAnod
            public class ClsDInspAnodSP
            {
                    public const string ID = "ID";
                    public const string date = "date";
                    public const string MONo = "MONo";
                    public const string StaffID = "StaffID";
                    public const string IOKQty = "IOKQty";
                    public const string INGQty = "INGQty";
                    public const string Note = "Note";
                    public const string Finished = "Finished";
                
            }
            #endregion

            #region DInspF3
            public class ClsDInspF3SP
            {
                    public const string ID = "@ID";
                    public const string date = "@date";
                    public const string MONo = "@MONo";
                    public const string StaffID = "@StaffID";
                    public const string F3OKQty = "@F3OKQty";
                    public const string F3SPQty = "@F3SPQty";
                    public const string F3NGQty = "@F3NGQty";
                    public const string Note = "@Note";
                    public const string Finished = "@Finished";
                
            }
            #endregion

            #region DMachineHand
            public class ClsDMachineHandSP
            {
                    public const string ID = "@ID";
                    public const string Date = "@Date";
                    public const string StaffID = "@StaffID";
                    public const string MONo = "@MONo";
                    public const string OKQty = "@OKQty";
                    public const string NGQty = "@NGQty";
                    public const string Note = "@Note";
                    public const string Finished = "@Finished";
                
            }
            #endregion

            #region DMBusInsp
            public class ClsDMBusInspSP
            {
                    public const string ID = "ID";
                    public const string date = "date";
                    public const string MONo = "MONo";
                    public const string StaffID = "StaffID";
                    public const string RBusInspQty = "RBusInspQty";
                    public const string Note = "Note";
                    public const string Finished = "Finished";
                
            }
            #endregion

            #region DMHandInsp
            public class ClsDMHandInspSP
            {
                    public const string ID = "@ID";
                    public const string Date = "@Date";
                    public const string MONo = "@MONo";
                    public const string StaffID = "@StaffID";
                    public const string ROKQty = "@ROKQty";
                    public const string RNGQty = "@RNGQty";
                    public const string Note = "@Note";
                    public const string Finished = "@Finished";
                
            }
            #endregion

            #region DMInspBus
            public class ClsDMInspBusSP
            {
                    public const string ID = "@ID";
                    public const string date = "@date";
                    public const string MONo = "@MONo";
                    public const string StaffID = "@StaffID";
                    public const string RInspBusQty = "@RInspBusQty";
                    public const string note = "@note";
                    public const string Finished = "@Finished";
                
            }
            #endregion

            #region DMInspHand
            public class ClsDMInspHandSP
            {
                    public const string ID = "@ID";
                    public const string date = "@date";
                    public const string MONo = "@MONo";
                    public const string StaffID = "@StaffID";
                    public const string RQty = "@RQty";
                    public const string Note = "@Note";
                    public const string Finished = "@Finished";
                
            }
            #endregion

            #region LaborWTS
            public class ClsLaborWTSSP
            {
                    public const string ID = "@ID";
                    public const string date = "@date";
                    public const string Shift = "@Shift";
                    public const string StaffID = "@StaffID";
                    public const string MachineID = "@MachineID";
                    public const string MONo = "@MONo";
                    public const string OptionID = "@OptionID";
                    public const string WorkID = "@WorkID";
                    public const string time = "@time";
                    public const string OKQty = "@OKQty";
                    public const string NGQty = "@NGQty";
                    public const string ProTime = "@ProTime";
                    public const string Clamptime = "@Clamptime";
                    public const string Note1 = "@Note1";
                    public const string Note2 = "@Note2";
                    public const string From = "@From";
                    public const string To = "@To";
                    public const string SProTime = "@SProTime";
                    public const string SClampTime = "@SClampTime";
                    public const string TOKQty = "@TOKQty";
                    public const string TNGQty = "@TNGQty";
                
            }
            #endregion

            #region MachineWTS
            public class ClsMachineWTSSP
            {
                    public const string ID = "@ID";
                    public const string date = "@date";
                    public const string Shift = "@Shift";
                    public const string MachineID = "@MachineID";
                    public const string StaffID = "@StaffID";
                    public const string MONo = "@MONo";
                    public const string OptionID = "@OptionID";
                    public const string WorkID = "@WorkID";
                    public const string Time = "@Time";
                    public const string OKQty = "@OKQty";
                    public const string NGQty = "@NGQty";
                    public const string ProTime = "@ProTime";
                    public const string ClampTime = "@ClampTime";
                    public const string Note1 = "@Note1";
                    public const string Note2 = "@Note2";
                    public const string From = "@From";
                    public const string to = "@to";
                    public const string SProTime = "@SProTime";
                    public const string SClampTime = "@SClampTime";
                    public const string TOKQty = "@TOKQty";
                    public const string TNGQty = "@TNGQty";
                
            }
            #endregion

            #region MaterialForm
            public class ClsMaterialFormSP
            {
                    public const string ID = "@ID";
                    public const string MaterialFormID = "@MaterialFormID";
                
            }
            #endregion

            #region MO
            public class ClsMOSP
            {
                    public const string MONo = "@MONo";
                    public const string date = "@date";
                    public const string PartID = "@PartID";
                    public const string MOQty = "@MOQty";
                    public const string DeadLine = "@DeadLine";
                    public const string HelisertQty = "@HelisertQty";
                    public const string BlastQty = "@BlastQty";
                    public const string Started = "@Started";
                    public const string startdate = "@startdate";
                    public const string Finished = "@Finished";
                    public const string Finishdate = "@Finishdate";
                    public const string OKQty = "@OKQty";
                    public const string NGQty = "@NGQty";
                    public const string Imported = "@Imported";
                    public const string Note = "@Note";
                
            }
            #endregion

            #region MOgetData
            public class ClsMOgetDataSP
            {
                    public const string ID = "@ID";
                    public const string Oder = "@Oder";
                    public const string PartID = "@PartID";
                    public const string Qty = "@Qty";
                    public const string Dealine = "@Dealine";
                    public const string In_Plan = "@In_Plan";
                    public const string Out_Plan = "@Out_Plan";
                
            }
            #endregion

            #region MOMaterial
            public class ClsMOMaterialSP
            {
                    public const string ID = "@ID";
                    public const string MONo = "@MONo";
                    public const string PartID = "@PartID";
                    public const string MaterialID = "@MaterialID";
                    public const string MaterialType = "@MaterialType";
                    public const string CutSize = "@CutSize";
                    public const string MaterialPrice = "@MaterialPrice";
                    public const string Shape = "@Shape";
                    public const string Thickness = "@Thickness";
                    public const string lenght = "@lenght";
                    public const string width = "@width";
                    public const string Price = "@Price";
                    public const string Finished = "@Finished";
                    public const string Finishdate = "@Finishdate";
                    public const string Note = "@Note";
                
            }
            #endregion

            #region MOOption
            public class ClsMOOptionSP
            {
                    public const string ID = "@ID";
                    public const string MONo = "@MONo";
                    public const string PartID = "@PartID";
                    public const string MOQty = "@MOQty";
                    public const string Deadline = "@Deadline";
                    public const string MachineID = "@MachineID";
                    public const string OptionID = "@OptionID";
                    public const string LastOption = "@LastOption";
                    public const string JigID = "@JigID";
                    public const string ProTime = "@ProTime";
                    public const string Finished = "@Finished";
                    public const string Finishdate = "@Finishdate";
                    public const string FinishMachine = "@FinishMachine";
                    public const string Shift = "@Shift";
                    public const string Note = "@Note";
                
            }
            #endregion

            #region NGCheck
            public class ClsNGCheckSP
            {
                    public const string ID = "@ID";
                    public const string Date = "@Date";
                    public const string MONo = "@MONo";
                    public const string StaffID = "@StaffID";
                    public const string OptionID = "@OptionID";
                    public const string justment = "@justment";
                    public const string Qty = "@Qty";
                    public const string Note = "@Note";
                    public const string Finished = "@Finished";
                
            }
            #endregion

            #region Option
            public class ClsOptionSP
            {
                    public const string OptionID = "@OptionID";
                    public const string OptionName = "@OptionName";
                    public const string Labor = "@Labor";
                
            }
            #endregion

            #region OptionData
            public class ClsOptionDataSP
            {
                    public const string ID = "@ID";
                    public const string InputDate = "@InputDate";
                    public const string PartID = "@PartID";
                    public const string MachineID = "@MachineID";
                    public const string OptionID = "@OptionID";
                    public const string LastOption = "@LastOption";
                    public const string JigID = "@JigID";
                    public const string ToolQty = "@ToolQty";
                    public const string ProTime = "@ProTime";
                    public const string ClampTime = "@ClampTime";
                    public const string TechDate = "@TechDate";
                    public const string UpdateDay = "@UpdateDay";
                    public const string Jig = "@Jig";
                    public const string JigType = "@JigType";
                    public const string StaffID = "@StaffID";
                    public const string Note = "@Note";
                    public const string AondNote = "@AondNote";
                    public const string Memo = "@Memo";
                    public const string CLUpdateday = "@CLUpdateday";
                
            }
            #endregion

            #region ORDERKH
            public class ClsSPORDERKHSP
            {
                    public const string ID = "@ID";
                    public const string Date = "@Date";
                    public const string MONo = "@MONo";
                
            }
            #endregion

            #region Overtime
            public class ClsOvertimeSP
            {
                    public const string ID = "@ID";
                    public const string Date = "@Date";
                    public const string StaffID = "@StaffID";
                    public const string Time = "@Time";
                
            }
            #endregion

            #region PartData
            public class ClsPartDataSP
            {
                    public const string ID = "@ID";
                    public const string InputDate = "@InputDate";
                    public const string PartID = "@PartID";
                    public const string MaterialID = "@MaterialID";
                    public const string MaterialType = "@MaterialType";
                    public const string Workpiecesize = "@Workpiecesize";
                    public const string shape = "@shape";
                    public const string Thickness = "@Thickness";
                    public const string width = "@width";
                    public const string lenght = "@lenght";
                    public const string Cut = "@Cut";
                    public const string RawMachine = "@RawMachine";
                    public const string HandFinish = "@HandFinish";
                    public const string HairLine = "@HairLine";
                    public const string WAnod = "@WAnod";
                    public const string BAnod = "@BAnod";
                    public const string Blast30 = "@Blast30";
                    public const string Blast60 = "@Blast60";
                    public const string Seal = "@Seal";
                    public const string Migaki = "@Migaki";
                    public const string Bafu = "@Bafu";
                    public const string Cleanwave = "@Cleanwave";
                    public const string VacPac = "@VacPac";
                    public const string Helisert = "@Helisert";
                    public const string SerialNo = "@SerialNo";
                    public const string PalCoat = "@PalCoat";
                    public const string Otherpro = "@Otherpro";
                    public const string Price = "@Price";
                    public const string Memo = "@Memo";
                    public const string Note = "@Note";
                    public const string Caciras = "@Caciras";
                    public const string Inside = "@Inside";
                
            }
            #endregion

            #region PCPKD
            public class ClsPCPKDSP
            {
                    public const string ID = "@ID";
                    public const string PType = "@PType";
                
            }
            #endregion

            #region WTSTOGA
            public class clsWTSTOGASP
            {
                    public const string ID = "@ID";
                    public const string Date = "@Date";
                    public const string Shift = "@Shift";
                    public const string StaffID = "@StaffID";
                    public const string MachineID = "@MachineID";
                    public const string MONo = "@MONo";
                    public const string WorkID = "@WorkID";
                    public const string Time = "@Time";
                
            }
            #endregion

            #region DeadlineCheck
            public class ClsDeadlineCheckSP
            {
                    public const string BOderNo = "@BOderNo";
                    public const string PartID = "@PartID";
                    public const string Qty = "@Qty";
                    public const string Dealine = "@Deadline";
            }
            #endregion

            #region Expence
            public class ClsExpenceSP
            {
                    public const string ExpenceID = "@ExpenceID";
                    public const string Description = "@Description";
                    public const string LaborExp = "@LaborExp";
            }
            #endregion

            #region MonthlyExpence
            public class ClsMonthlyExpenceSP
            {
                public const string ID = "@ID";
                    public const string ExpenceID = "@ExpenceID";
                    public const string YearMonth = "@YearMonth";
                    public const string Amount = "@Amount";
            }
            #endregion
            public class ClsWorkSP
            {
                    public const string WorkID = "@WorkID";
                    public const string WorkName = "@WorkName";
                    public const string DirectWork = "@DirectWork";
                    public const string MachWork = "@MachWork";
                    public const string MachInDWork = "@MachInDWork";
                    public const string MachineRun = "@MachineRun";
            }

            #region Machine
            public class ClsMachineSP
            {
                    public const string MachineID = "@MachineID";
                    public const string MakerMachineNo = "@MakerMachineNo";
                    public const string AccName = "@AccName";
                    public const string DensanName = "@DensanName";
                    public const string DensanCode = "@DensanCode";
                    public const string Dmachine = "@Dmachine";
                    public const string MachineName = "@MachineName";
                    public const string MachineGR = "@MachineGR";
                    public const string Maker = "@Maker";
                    public const string Charge = "@Charge";
                    public const string Ratio = "@Ratio";
                    public const string kakokikai = "@kakokikai";
                    public const string MultiPalet = "@MultiPalet";
            }
            #endregion

            #region MachineGroup
            public class ClsMachineGroupSP
            {
                    public const string MachineGP = "@MachineGP";
                    public const string MGroupName = "@MGroupName";
                    public const string MaQuantiy = "@MaQuantiy";
                    public const string Content = "@Content";
            }
            #endregion

            #region Material
            public class ClsMaterialSP
            {
                public const string MaterialID = "@MaterialID";
                public const string Density = "@Density";
                public const string UnitPrice = "@UnitPrice";
                public const string Type = "@Type";
            }
            #endregion

            #region DataANO
            public class ClsDulieuANOSP
            {
                public const string ID = "@ID";
                public const string Date = "@Date";
                public const string OrderNo = "@OrderNo";
                public const string PartNo = "@PartNo";
                public const string AnoNo = "@AnoNo";
                public const string MoQuan = "@MoQuan";
                public const string AnoQuan = "@AnoQuan";
                public const string Tank3_Temp = "@Tank3_Temp";
                public const string Tank3_NaOH = "@Tank3_NaOH";
                public const string Tank3_Times = "@Tank3_Times";
                public const string Tank8_H2SO4 = "@Tank8_H2SO4";
                public const string Tank8_Temp = "@Tank8_Temp";
                public const string Tank8_Times = "@Tank8_Times";
                public const string Maibong = "@Maibong";
                public const string Maibong_Temp = "@Maibong_Temp";
                public const string Maibong_Times = "@Maibong_Times";
                public const string Times = "@Times";
                public const string Code = "@Code";
                public const string Sltreo = "@Sltreo";
                public const string P_sinh = "@P_sinh";
                public const string Phuong_phap = "@Phuong_phap";
                public const string Chieu_day_mang = "@Chieu_day_mang";

            }
            #endregion
        
    }
}
